
/**
	AUTHOR		: VEERU
	DATE		: FEB 15th 2004
	DESCRIPTION	: THIS PROCEDURE IS USED TO DEACTIVATE THE VENDOR SHIPPER RELATIONSHIP
*/

CREATE  PROC SP_DEACTIVATE_VENDOR_SHIPPER_RELATIONSHIPS

@VENDOR_ID INT
AS
BEGIN
	DECLARE @STATUS_ID INT

	SELECT @STATUS_ID = RELATIONSHIPSTATUS_ID FROM CUSTOMER_RELATIONSHIP_STATUS WHERE NAME = 'INACTIVE'
	UPDATE VENDOR_SHIPPER_RELATIONSHIP SET RELATIONSHIPSTATUS_ID = @STATUS_ID WHERE VENDOR_ID = @VENDOR_ID
	
END